/*
 Navicat Premium Dump SQL

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 80040 (8.0.40)
 Source Host           : localhost:3306
 Source Schema         : nacos

 Target Server Type    : MySQL
 Target Server Version : 80040 (8.0.40)
 File Encoding         : 65001

 Date: 27/02/2025 18:00:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config_info
-- ----------------------------
DROP TABLE IF EXISTS `config_info`;
CREATE TABLE `config_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'group_id',
  `content` longtext COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  `app_name` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `c_desc` varchar(256) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'configuration description',
  `c_use` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'configuration usage',
  `effect` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL COMMENT '配置生效的描述',
  `type` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL COMMENT '配置的类型',
  `c_schema` text COLLATE utf8mb3_bin COMMENT '配置的模式',
  `encrypted_data_key` varchar(1024) COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '密钥',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info';

-- ----------------------------
-- Records of config_info
-- ----------------------------
BEGIN;
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (1, 'application-common.yml', 'DEFAULT_GROUP', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  redis:\n    host: localhost\n    port: 6379\n    password: sunjing233\n    timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', 'fb6abb8ab1b1be4e327e44b78f97c740', '2025-02-14 18:16:59', '2025-02-14 18:21:54', 'nacos', '192.168.65.1', '', 'af0cefa4-3134-4ee5-ba99-2cdac377026c', '微服务通用配置', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (2, 'application-common.yml', 'DEFAULT_GROUP', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: sunjing233\n      timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n      # 全局逻辑删除字段名\n      logic-delete-field: deleted \n      logic-delete-value: 1\n      logic-not-delete-value: 0\n############## Sa-Token 配置 (文档: https://sa-token.cc) ##############\nsa-token: \n    # token 名称（同时也是 cookie 名称）\n    token-name: satoken\n    # token 有效期（单位：秒） 默认30天，-1 代表永久有效\n    timeout: 2592000\n    # token 最低活跃频率（单位：秒），如果 token 超过此时间没有访问系统就会被冻结，默认-1 代表不限制，永不冻结\n    active-timeout: -1\n    # 是否允许同一账号多地同时登录 （为 true 时允许一起登录, 为 false 时新登录挤掉旧登录）\n    is-concurrent: true\n    # 在多人登录同一账号时，是否共用一个 token （为 true 时所有登录共用一个 token, 为 false 时每次登录新建一个 token）\n    is-share: true\n    # token 风格（默认可取值：uuid、simple-uuid、random-32、random-64、random-128、tik）\n    token-style: uuid\n    # 是否输出操作日志 \n    is-log: true\n    ', 'e24bd9b34f1ea114b451079fef63f2e4', '2025-02-14 18:39:30', '2025-02-15 15:47:21', 'nacos', '192.168.65.1', '', '', '通用配置', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (3, 'vben-gateway.yml', 'DEFAULT_GROUP', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system\n          uri: lb://vben-service-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # AI服务\n        - id: vben-service-ai\n          uri: lb://vben-service-ai\n          predicates:\n            - Path=/ai/**\n          filters:\n            - StripPrefix=1\n        # 文件服务\n        - id: vben-service-file\n          uri: lb://vben-service-file\n          predicates:\n            - Path=/file/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', 'a563f3e894b31aa344e86a27457b45e8', '2025-02-15 03:29:46', '2025-02-25 16:10:57', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (4, 'vben-service-system.yml', 'DEFAULT_GROUP', 'springdoc:\n  api-docs:\n    path: /v3/api-docs\n  swagger-ui:\n    path: /swagger-ui.html', 'b2baa534f5346ca8007f736954a6fc09', '2025-02-16 04:15:18', '2025-02-16 04:15:18', 'nacos', '192.168.65.1', '', '', '系统服务配置', NULL, NULL, 'yaml', NULL, '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (5, 'vben-service-ai.yml', 'DEFAULT_GROUP', 'spring:\n  ai:\n    chat:\n      client:\n        enable: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\nsocketio:\n  host: 127.0.0.1  # 本地测试可设置为 localhost 或本机IP，在Linux服务器可换成服务器IP\n  port: 9021\n  maxFramePayloadLength: 1048576  # 设置最大每帧处理数据的长度，防止大数据攻击\n  maxHttpContentLength: 10485760  # 设置HTTP交互最大内容长度\n  bossCount: 1  # socket 连接数大小（如只监听一个端口，boss 线程组为1）\n  workCount: 100  # 工作线程数\n  allowCustomRequests: true  # 允许自定义请求\n  upgradeTimeout: 1000000  # 协议升级超时时间（毫秒），HTTP握手升级为WS协议超时\n  pingTimeout: 6000000  # Ping 消息超时时间（毫秒），超时未收到心跳消息将触发超时事件\n  pingInterval: 25000  # Ping 消息间隔（毫秒），客户端向服务器发送心跳消息的间隔\n', '9a882a95317ec724843b8af9807b0772', '2025-02-24 06:44:16', '2025-02-26 13:05:06', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
INSERT INTO `config_info` (`id`, `data_id`, `group_id`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `app_name`, `tenant_id`, `c_desc`, `c_use`, `effect`, `type`, `c_schema`, `encrypted_data_key`) VALUES (6, 'vben-service-file.yml', 'DEFAULT_GROUP', 'spring:\n  servlet:\n    multipart:\n      max-file-size: 100MB\n      max-request-size: 100MB\ndromara:\n  x-file-storage: #文件存储配置\n    default-platform: aliyun-oss-1 #默认使用的存储平台\n    aliyun-oss:\n      - platform: aliyun-oss-1 # 存储平台标识\n        enable-storage: true  # 启用存储\n        access-key: LTAI5tJfZZp9XsHZs8rH3EXx\n        secret-key: Ze3uXVZNjwhWKzlsyoBXy3bSBq9jB1\n        end-point: oss-rg-china-mainland.aliyuncs.com\n        bucket-name: vben-cloud\n        domain: https://vben-cloud.oss-rg-china-mainland.aliyuncs.com/\n        base-path: img/', 'f04673eb2dbdf775bab531c6d2e4138b', '2025-02-25 16:00:25', '2025-02-25 16:47:09', 'nacos', '192.168.65.1', '', '', '', '', '', 'yaml', '', '');
COMMIT;

-- ----------------------------
-- Table structure for config_info_aggr
-- ----------------------------
DROP TABLE IF EXISTS `config_info_aggr`;
CREATE TABLE `config_info_aggr` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `datum_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'datum_id',
  `content` longtext COLLATE utf8mb3_bin NOT NULL COMMENT '内容',
  `gmt_modified` datetime NOT NULL COMMENT '修改时间',
  `app_name` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='增加租户字段';

-- ----------------------------
-- Records of config_info_aggr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_beta
-- ----------------------------
DROP TABLE IF EXISTS `config_info_beta`;
CREATE TABLE `config_info_beta` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `beta_ips` varchar(1024) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'betaIps',
  `md5` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` varchar(1024) COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '密钥',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info_beta';

-- ----------------------------
-- Records of config_info_beta
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_info_tag
-- ----------------------------
DROP TABLE IF EXISTS `config_info_tag`;
CREATE TABLE `config_info_tag` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `tag_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_id',
  `app_name` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_info_tag';

-- ----------------------------
-- Records of config_info_tag
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for config_tags_relation
-- ----------------------------
DROP TABLE IF EXISTS `config_tags_relation`;
CREATE TABLE `config_tags_relation` (
  `id` bigint NOT NULL COMMENT 'id',
  `tag_name` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'tag_name',
  `tag_type` varchar(64) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tag_type',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `nid` bigint NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增长标识',
  PRIMARY KEY (`nid`),
  UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='config_tag_relation';

-- ----------------------------
-- Records of config_tags_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_capacity
-- ----------------------------
DROP TABLE IF EXISTS `group_capacity`;
CREATE TABLE `group_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Group ID，空字符表示整个集群',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数，，0表示使用默认值',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='集群、各Group容量信息表';

-- ----------------------------
-- Records of group_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for his_config_info
-- ----------------------------
DROP TABLE IF EXISTS `his_config_info`;
CREATE TABLE `his_config_info` (
  `id` bigint unsigned NOT NULL COMMENT 'id',
  `nid` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'nid, 自增标识',
  `data_id` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT 'data_id',
  `group_id` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'group_id',
  `app_name` varchar(128) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'app_name',
  `content` longtext COLLATE utf8mb3_bin NOT NULL COMMENT 'content',
  `md5` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'md5',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `src_user` text COLLATE utf8mb3_bin COMMENT 'source user',
  `src_ip` varchar(50) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'source ip',
  `op_type` char(10) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'operation type',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT '租户字段',
  `encrypted_data_key` varchar(1024) COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT '密钥',
  PRIMARY KEY (`nid`),
  KEY `idx_gmt_create` (`gmt_create`),
  KEY `idx_gmt_modified` (`gmt_modified`),
  KEY `idx_did` (`data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='多租户改造';

-- ----------------------------
-- Records of his_config_info
-- ----------------------------
BEGIN;
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 1, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', '918132bc41436180f5ad5e3cb1a75537', '2025-02-14 18:16:59', '2025-02-15 02:16:59', 'nacos', '192.168.65.1', 'I', 'af0cefa4-3134-4ee5-ba99-2cdac377026c', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (1, 2, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', '918132bc41436180f5ad5e3cb1a75537', '2025-02-14 18:18:38', '2025-02-15 02:18:38', 'nacos', '192.168.65.1', 'U', 'af0cefa4-3134-4ee5-ba99-2cdac377026c', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (1, 3, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  redis:\n    host: localhost\n    port: 6379\n    password: sunjing233\n    timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', 'fb6abb8ab1b1be4e327e44b78f97c740', '2025-02-14 18:21:53', '2025-02-15 02:21:54', 'nacos', '192.168.65.1', 'U', 'af0cefa4-3134-4ee5-ba99-2cdac377026c', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 4, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  redis:\n    host: localhost\n    port: 6379\n    password: sunjing233\n    timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', 'fb6abb8ab1b1be4e327e44b78f97c740', '2025-02-14 18:39:29', '2025-02-15 02:39:30', 'nacos', '192.168.65.1', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (2, 5, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  redis:\n    host: localhost\n    port: 6379\n    password: sunjing233\n    timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', 'fb6abb8ab1b1be4e327e44b78f97c740', '2025-02-14 18:55:57', '2025-02-15 02:55:58', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 6, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1', 'cb7d913abd5b89ab44a643b83bbb7338', '2025-02-15 03:29:46', '2025-02-15 11:29:46', 'nacos', '192.168.65.1', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 7, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1', 'cb7d913abd5b89ab44a643b83bbb7338', '2025-02-15 03:31:42', '2025-02-15 11:31:43', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 8, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        ', '11904c6025c2dfcd3db9806a7f5b86db', '2025-02-15 08:43:06', '2025-02-15 16:43:07', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (2, 9, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: sunjing233\n      timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n    ', 'a6846687f8063e2f85908e4e94b81402', '2025-02-15 09:49:29', '2025-02-15 17:49:30', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (2, 10, 'application-common.yml', 'DEFAULT_GROUP', '', '# 数据源\nspring:\n  datasource:\n    url: jdbc:mysql://localhost:3306/vben_cloud?allowPublicKeyRetrieval=True\n    username: root\n    password: sunjing233\n    driver-class-name: com.mysql.cj.jdbc.Driver\n  data:\n    redis:\n      host: localhost\n      port: 6379\n      password: sunjing233\n      timeout: 3000\n#Mybatis-Plus\nmybatis-plus:\n  configuration:\n    # MyBatis 配置\n    map-underscore-to-camel-case: true\n  global-config:\n    # 全局配置\n    db-config:\n      # 数据库配置\n      id-type: ASSIGN_ID\n      # 全局逻辑删除字段名\n      logic-delete-field: deleted \n      logic-delete-value: 1\n      logic-not-delete-value: 0\n    ', 'c1056d22ac3743184e6132218ff8137d', '2025-02-15 15:47:21', '2025-02-15 23:47:21', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 11, 'vben-service-system.yml', 'DEFAULT_GROUP', '', 'springdoc:\n  api-docs:\n    path: /v3/api-docs\n  swagger-ui:\n    path: /swagger-ui.html', 'b2baa534f5346ca8007f736954a6fc09', '2025-02-16 04:15:18', '2025-02-16 12:15:18', 'nacos', '192.168.65.1', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 12, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', '330383285be0ca03f1da4a50c2446819', '2025-02-16 04:25:22', '2025-02-16 12:25:22', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 13, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n    - /**/swagger-ui.html\n        ', 'dba1f33655fa1a579bd21fd0854e946e', '2025-02-16 04:26:18', '2025-02-16 12:26:19', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 14, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', '330383285be0ca03f1da4a50c2446819', '2025-02-16 04:26:44', '2025-02-16 12:26:45', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 15, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system-biz\n          uri: lb://vben-service-system-biz\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', '330383285be0ca03f1da4a50c2446819', '2025-02-16 04:27:54', '2025-02-16 12:27:55', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 16, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', '  ai.dashscope:\n    api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n    chat:\n      options:\n        model: qwen-max\n', 'a1216e02e8102158d09396535b07a845', '2025-02-24 06:44:15', '2025-02-24 14:44:16', 'nacos', '192.168.65.1', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 17, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', '  ai.dashscope:\n    api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n    chat:\n      options:\n        model: qwen-max\n', 'a1216e02e8102158d09396535b07a845', '2025-02-24 06:50:10', '2025-02-24 14:50:11', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 18, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system\n          uri: lb://vben-service-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', 'd0cf8e97d6f18e7f1abb3b1c419729c6', '2025-02-24 06:51:21', '2025-02-24 14:51:22', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 19, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n    chat:\n      options:\n        model: qwen-max\n', 'a5da1c13bc583c282dcbb6f0a55c95b6', '2025-02-25 03:03:51', '2025-02-25 11:03:51', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 20, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n      embedding:\n        enabled: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', 'dff72eb2c43e0a8f7d419a750f6212e9', '2025-02-25 03:06:55', '2025-02-25 11:06:56', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 21, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    chat:\n      client:\n        enabled: false    \n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', '863d5a2cf162f3fd1a4b9872d0601395', '2025-02-25 03:10:35', '2025-02-25 11:10:36', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 22, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n      embedding:\n        enabled: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', 'd3ee4339729f4a95c992325b9449ecc9', '2025-02-25 05:31:33', '2025-02-25 13:31:33', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 23, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    chat:\n      client:\n        enabled: false\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n      embedding:\n        enabled: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', '4a1fef24c09134ede2f5ad079a4a7b15', '2025-02-25 05:51:20', '2025-02-25 13:51:21', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 24, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    chat:\n      client:\n        enabled: false\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n      embedding:\n        enabled: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', 'feeb2c944f821c62b2517a31282bcfc8', '2025-02-25 05:52:46', '2025-02-25 13:52:47', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 25, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    chat:\n      client:\n        enabled: false\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/chat/completions\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n      embedding:\n        enabled: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', '16b050be24e2b73124d7734e491c4cf7', '2025-02-25 05:53:50', '2025-02-25 13:53:50', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 26, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    chat:\n      client:\n        enabled: false\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1/chat/completions\n      chat:\n        options:\n          model: Pro/deepseek-ai/DeepSeek-R1\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', 'b204b094ad680c4cca4bdbf982b88733', '2025-02-25 05:58:27', '2025-02-25 13:58:27', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 27, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:  \n    chat:\n      client:\n        enabled: false\n    openai:\n      api-key: sk-makpxavhfximrihrpjoqlzeqtfasieotjdwecagvejfvpsxb\n      base-url: https://api.siliconflow.cn/v1\n      chat:\n        options:\n          model: deepseek-ai/DeepSeek-R1\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', '3bc949814b407d05ff6da908054aec9c', '2025-02-25 06:07:03', '2025-02-25 14:07:04', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 28, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', '4d13526956575e7430401d03bcb591cd', '2025-02-25 06:16:01', '2025-02-25 14:16:01', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 29, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    chat:\n      client:\n        enable: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\n', 'f64ab409ebb663ffc81ca1f2974fb747', '2025-02-25 08:26:45', '2025-02-25 16:26:45', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (0, 30, 'vben-service-file.yml', 'DEFAULT_GROUP', '', 'dromara:\n  x-file-storage: #文件存储配置\n    default-platform: aliyun-oss-1 #默认使用的存储平台\n    aliyun-oss:\n      - platform: aliyun-oss-1 # 存储平台标识\n        enable-storage: true  # 启用存储\n        access-key: LTAI5tJfZZp9XsHZs8rH3EXx\n        secret-key: Ze3uXVZNjwhWKzlsyoBXy3bSBq9jB1\n        end-point: oss-rg-china-mainland.aliyuncs.com\n        bucket-name: vben-cloud\n        domain: https://vben-cloud.oss-rg-china-mainland.aliyuncs.com/\n        base-path: img', 'f34e4215ff74b57c9921e56fe4cdc815', '2025-02-25 16:00:25', '2025-02-26 00:00:25', 'nacos', '192.168.65.1', 'I', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (3, 31, 'vben-gateway.yml', 'DEFAULT_GROUP', '', 'spring:\n  cloud:\n    gateway:\n      routes:\n        # 认证授权服务\n        - id: vben-auth\n          uri: lb://vben-auth\n          predicates:\n            - Path=/auth/**\n          filters:\n            - StripPrefix=1\n        # 系统服务\n        - id: vben-service-system\n          uri: lb://vben-service-system\n          predicates:\n            - Path=/system/**\n          filters:\n            - StripPrefix=1\n        # AI服务\n        - id: vben-service-ai\n          uri: lb://vben-service-ai\n          predicates:\n            - Path=/ai/**\n          filters:\n            - StripPrefix=1\n#黑白名单配置\nsecurity:\n  allow:\n    - /auth/**\n  block:\n        ', '726e116ffd9a00dcc73a4d4e490dda10', '2025-02-25 16:10:56', '2025-02-26 00:10:57', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 32, 'vben-service-file.yml', 'DEFAULT_GROUP', '', 'dromara:\n  x-file-storage: #文件存储配置\n    default-platform: aliyun-oss-1 #默认使用的存储平台\n    aliyun-oss:\n      - platform: aliyun-oss-1 # 存储平台标识\n        enable-storage: true  # 启用存储\n        access-key: LTAI5tJfZZp9XsHZs8rH3EXx\n        secret-key: Ze3uXVZNjwhWKzlsyoBXy3bSBq9jB1\n        end-point: oss-rg-china-mainland.aliyuncs.com\n        bucket-name: vben-cloud\n        domain: https://vben-cloud.oss-rg-china-mainland.aliyuncs.com/\n        base-path: img', 'f34e4215ff74b57c9921e56fe4cdc815', '2025-02-25 16:27:10', '2025-02-26 00:27:10', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 33, 'vben-service-file.yml', 'DEFAULT_GROUP', '', 'spring:\n  servlet:\n    multipart:\n      max-file-size: 10MB\n      max-request-size: 10MB\ndromara:\n  x-file-storage: #文件存储配置\n    default-platform: aliyun-oss-1 #默认使用的存储平台\n    aliyun-oss:\n      - platform: aliyun-oss-1 # 存储平台标识\n        enable-storage: true  # 启用存储\n        access-key: LTAI5tJfZZp9XsHZs8rH3EXx\n        secret-key: Ze3uXVZNjwhWKzlsyoBXy3bSBq9jB1\n        end-point: oss-rg-china-mainland.aliyuncs.com\n        bucket-name: vben-cloud\n        domain: https://vben-cloud.oss-rg-china-mainland.aliyuncs.com/\n        base-path: img', 'e110ec56020ac61ab129922acecb0ecc', '2025-02-25 16:27:53', '2025-02-26 00:27:54', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (6, 34, 'vben-service-file.yml', 'DEFAULT_GROUP', '', 'spring:\n  servlet:\n    multipart:\n      max-file-size: 10MB\n      max-request-size: 10MB\ndromara:\n  x-file-storage: #文件存储配置\n    default-platform: aliyun-oss-1 #默认使用的存储平台\n    aliyun-oss:\n      - platform: aliyun-oss-1 # 存储平台标识\n        enable-storage: true  # 启用存储\n        access-key: LTAI5tJfZZp9XsHZs8rH3EXx\n        secret-key: Ze3uXVZNjwhWKzlsyoBXy3bSBq9jB1\n        end-point: oss-rg-china-mainland.aliyuncs.com\n        bucket-name: vben-cloud\n        domain: https://vben-cloud.oss-rg-china-mainland.aliyuncs.com/\n        base-path: img/', '23e990af16c404d94e818c6e05077a9b', '2025-02-25 16:47:09', '2025-02-26 00:47:09', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 35, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    chat:\n      client:\n        enable: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\nsocketio:\n  host: localhost  # 本地测试可设置为 localhost 或本机IP，在Linux服务器可换成服务器IP\n  port: 9021\n  maxFramePayloadLength: 1048576  # 设置最大每帧处理数据的长度，防止大数据攻击\n  maxHttpContentLength: 10485760  # 设置HTTP交互最大内容长度\n  bossCount: 1  # socket 连接数大小（如只监听一个端口，boss 线程组为1）\n  workCount: 100  # 工作线程数\n  allowCustomRequests: true  # 允许自定义请求\n  upgradeTimeout: 1000000  # 协议升级超时时间（毫秒），HTTP握手升级为WS协议超时\n  pingTimeout: 6000000  # Ping 消息超时时间（毫秒），超时未收到心跳消息将触发超时事件\n  pingInterval: 25000  # Ping 消息间隔（毫秒），客户端向服务器发送心跳消息的间隔\n', 'e4dd057f432876c2405458030988a273', '2025-02-26 00:25:31', '2025-02-26 08:25:31', 'nacos', '192.168.65.1', 'U', '', '');
INSERT INTO `his_config_info` (`id`, `nid`, `data_id`, `group_id`, `app_name`, `content`, `md5`, `gmt_create`, `gmt_modified`, `src_user`, `src_ip`, `op_type`, `tenant_id`, `encrypted_data_key`) VALUES (5, 36, 'vben-service-ai.yml', 'DEFAULT_GROUP', '', 'spring:\n  ai:\n    chat:\n      client:\n        enable: false\n    dashscope:\n      api-key: sk-4a30438afd504c96bb32e518f0f1de8f\nsocketio:\n  host: 192.168.20.129  # 本地测试可设置为 localhost 或本机IP，在Linux服务器可换成服务器IP\n  port: 9021\n  maxFramePayloadLength: 1048576  # 设置最大每帧处理数据的长度，防止大数据攻击\n  maxHttpContentLength: 10485760  # 设置HTTP交互最大内容长度\n  bossCount: 1  # socket 连接数大小（如只监听一个端口，boss 线程组为1）\n  workCount: 100  # 工作线程数\n  allowCustomRequests: true  # 允许自定义请求\n  upgradeTimeout: 1000000  # 协议升级超时时间（毫秒），HTTP握手升级为WS协议超时\n  pingTimeout: 6000000  # Ping 消息超时时间（毫秒），超时未收到心跳消息将触发超时事件\n  pingInterval: 25000  # Ping 消息间隔（毫秒），客户端向服务器发送心跳消息的间隔\n', '3df42062261e95ee5ff36c34166c9bc3', '2025-02-26 13:05:06', '2025-02-26 21:05:06', 'nacos', '192.168.65.1', 'U', '', '');
COMMIT;

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `role` varchar(50) NOT NULL COMMENT 'role',
  `resource` varchar(128) NOT NULL COMMENT 'resource',
  `action` varchar(8) NOT NULL COMMENT 'action',
  UNIQUE KEY `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `username` varchar(50) NOT NULL COMMENT 'username',
  `role` varchar(50) NOT NULL COMMENT 'role',
  UNIQUE KEY `idx_user_role` (`username`,`role`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` (`username`, `role`) VALUES ('nacos', 'ROLE_ADMIN');
COMMIT;

-- ----------------------------
-- Table structure for tenant_capacity
-- ----------------------------
DROP TABLE IF EXISTS `tenant_capacity`;
CREATE TABLE `tenant_capacity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin NOT NULL DEFAULT '' COMMENT 'Tenant ID',
  `quota` int unsigned NOT NULL DEFAULT '0' COMMENT '配额，0表示使用默认值',
  `usage` int unsigned NOT NULL DEFAULT '0' COMMENT '使用量',
  `max_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个配置大小上限，单位为字节，0表示使用默认值',
  `max_aggr_count` int unsigned NOT NULL DEFAULT '0' COMMENT '聚合子配置最大个数',
  `max_aggr_size` int unsigned NOT NULL DEFAULT '0' COMMENT '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值',
  `max_history_count` int unsigned NOT NULL DEFAULT '0' COMMENT '最大变更历史数量',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_id` (`tenant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='租户容量信息表';

-- ----------------------------
-- Records of tenant_capacity
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tenant_info
-- ----------------------------
DROP TABLE IF EXISTS `tenant_info`;
CREATE TABLE `tenant_info` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `kp` varchar(128) COLLATE utf8mb3_bin NOT NULL COMMENT 'kp',
  `tenant_id` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_id',
  `tenant_name` varchar(128) COLLATE utf8mb3_bin DEFAULT '' COMMENT 'tenant_name',
  `tenant_desc` varchar(256) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'tenant_desc',
  `create_source` varchar(32) COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'create_source',
  `gmt_create` bigint NOT NULL COMMENT '创建时间',
  `gmt_modified` bigint NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
  KEY `idx_tenant_id` (`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin COMMENT='tenant_info';

-- ----------------------------
-- Records of tenant_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `username` varchar(50) NOT NULL COMMENT 'username',
  `password` varchar(500) NOT NULL COMMENT 'password',
  `enabled` tinyint(1) NOT NULL COMMENT 'enabled',
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`username`, `password`, `enabled`) VALUES ('nacos', '$2a$10$i5YTC8KWZKAJacWNKF/.1ey8i.ujcbM9ANGkQu08XRrvWbFwR4Y/2', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
